﻿CREATE TABLE [dbo].[SeatRegion]
(
	Id int NOT NULL CONSTRAINT PK_SeatRegion PRIMARY KEY IDENTITY(1,1),
	Flight nvarchar(10) NOT NULL CONSTRAINT FK_SeatRegion_Flight REFERENCES Flight(Code), 
	ClassType int NOT NULL CONSTRAINT FK_SeatRegion_ClassType REFERENCES ClassType(Id),
	NumberOfSeat int NOT NULL,
)
